EDATE in excel help

Closed
1Audrey
Posts
2
Registration date
Friday April 7, 2017
Status
Member
Last seen
April 8, 2017
- Apr 8, 2017 at 02:02 AM
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
- Apr 8, 2017 at 02:21 AM
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

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Apr 8, 2017 at 02:21 AM
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.
0