EDATE in excel help [Closed]

Report
Posts
2
Registration date
Friday April 7, 2017
Status
Member
Last seen
April 8, 2017
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
-
Hello... I have a training for log for a large number of staff for various different courses which have all been completed at various different dates and I want to show the expiry dates for each entry in another worksheet. I am using the EDATE function (referencing back to a cell in another worksheet) to do this but it is returning an incorrect value. However when I use EDATE in the same worksheet it works fine? Please help, struggling with this one. Thanks in advance.

I also want to be able to copy this formula across but leaving the cell blank if there is no date entered in the original cell. I would greatly appreciate any help please, thank you for your time.

1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
19
Hi 1Audrey,

I am here to help you. Do you mind sharing some sample data here in the forum? I can try to build your scenario in an excel sheet and provide you with some input on how to solve the EDATE problem.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!