Hello!
I've got two questions concerning dates in excel.
1) I'd like to have a formula which updates the date every day (shows today's date)
2) How to subtract two dates to calculate the number of days between them?
See the file with detailed info. attached.
Regards
Arty
hi Arty_1,
formula for C2:
formula for B2 (dragged down):
Please Login or Register to view this content.
change format for B2:B... to numberPlease Login or Register to view this content.
In B2 Cell
=DATEDIF(C2,TODAY(),"D")
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
So simple as that!
Thanks guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks