Formulas for
Get solar times by the row. =VERVE("sunrisesunset", A2, B2) returns sunrise and sunset for a lat/lon — Google Sheets or Excel.
It's one of 250+ live sources you reach with a single =VERVE() function — served from APIVerve's production data engine, billed at 1 credit per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.
A real example — the input you type, and the values you can pull from it. Click any cell to see the formula behind it.
Put your cities in a column and fill =VERVE("sunrisesunset", 36.72016, -4.42034) beside them — every row shows live conditions, so an ops or travel sheet reflects the real world, not last week.
Gate a plan on the weather: read the forecast into a cell and let an IF formula flag rows that need a backup date.
Set the sheet to refresh on a schedule and Sunrise & Sunset keeps a status board current without anyone re-typing a thing.
The same function works in both apps — install once, sign in with your key, and type it into any cell.
Google SheetsAdd-onInstall from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.
=VERVE("sunrisesunset", 36.72016, -4.42034)
Microsoft ExcelAdd-inSame source, same arguments, same key — in Excel on desktop, the web, or mobile. Excel namespaces it as VERVE.CALL. Drag to fill a whole column.
=VERVE.CALL("sunrisesunset", 36.72016, -4.42034)Tune the result by adding name=value before the field argument — in any order. Leave one out and its default applies.
The date for which you want to get the sunrise and sunset times (e.g., MM-DD-YYYY : 01-01-2022)
=VERVE("sunrisesunset", 36.72016, -4.42034, "date", "01-16-2026")Add a field name as the last argument to land just that value in the cell.
=VERVE("sunrisesunset", 36.72016, -4.42034, "field", "data.sunrise")=VERVE("sunrisesunset", 36.72016, -4.42034, "field", "data.sunset")=VERVE("sunrisesunset", 36.72016, -4.42034, "field", "data.dayLength")=VERVE("sunrisesunset", 36.72016, -4.42034, "field", "data.solarNoon")=VERVE("sunrisesunset", 36.72016, -4.42034, "field", "data.civilTwilight")Premium marks data included on paid plans. On the Free plan a marked field is withheld and a marked input is ignored — either way the cell reads #PREMIUM(name) instead of a value, so a gated answer can never be mistaken for a real one. Everything unmarked works on every plan. Compare plans
Everything you need to wire it into a sheet.
