Need Help in calculating number if Days from current date.

**Shahbazk** · 02-19-2018, 11:06 AM

For Example -
I have 2 columns - A (Working Days) & B (Dates),

So if my current date is 19th Feb 2018 then in Cell D it should populate 101 + 1 more day i.e. 102 days

Attached excel sheet for reference.

**finalazy** · 02-19-2018, 11:11 AM

you mean like this?

=INDEX(A:A,MATCH(TODAY(),B:B,0))+1

**AlKey** · 02-19-2018, 11:13 AM

Try this

Formula:

Please Login or Register  to view this content.

Or this

Formula:

Please Login or Register  to view this content.

**davsth** · 02-19-2018, 11:34 AM

Or from the example, where there appear to be no holidays

=NETWORKDAYS(43007,TODAY())

Need Help in calculating number if Days from current date.

LinkBack

Thread Tools

Rate This Thread

Display

Need Help in calculating number if Days from current date.

Re: Need Help in calculating number if Days from current date.

Re: Need Help in calculating number if Days from current date.

Re: Need Help in calculating number if Days from current date.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count the number of days in the year to date less the days in the current month

[SOLVED] calculate number of days from current date

Calculating the number of days between 2 dates using today's date until 2nd date is added.

Need to count number of days from a given date in a cell from the current day

calculate number of days between two date within a current month including end date

Calculating Number of days from one date to another

[SOLVED] Calculating days between current date and a date in future NETWORKDAYS() fun

Bookmarks

Bookmarks

Posting Permissions