Excel Forum

Reset Excel filed value based on Today date?

p chava

New Member

Members

Forum Posts: 1

Member Since:
July 15, 2019

Offline

July 15, 2019 - 1:49 pm

Hi all,

I have Emplyoee HireDate and number of sick leave on monthly basis. (please find attached sample data).

I am trying to get, the sum of sick leave days has to reset to Zero autimatically for every 365days/1 year from HireDate.

any help really appreciated!

Thanks,

Pchava

Philip Treacy

Admin

Forum Posts: 1518

Member Since:
October 5, 2010

Offline

July 17, 2019 - 9:24 am

Hi,

I understand what you are asking but in your sample file, the Expected Output has no data in it and the sample data layout is incomplete?

Maybe using this would do what you want:

=IF(TODAY()=B14,0,SUM(C14:L14))

See attached workbook

Regards

Phil

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Jeanine Hagge

Guest(s) 11

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 205

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Othman AL MUTAIRI

Misael Gutierrez Sr.

Attif Ihsan

Kieran Fee

Murat Hasanoglu

Brett Dryland

Saeed Aldousari

Bhuwan Devkota

Kathryn Patton

Maria Conatser

Forum Stats:

Groups: 3

Forums: 24

Topics: 6222

Posts: 27293

Member Stats:

Guest Posters: 49

Members: 31917

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen